Overview
Brought to you by YData
Dataset statistics
| Prior Order Profile Report | Train Order Profile Report | |
|---|---|---|
| Number of variables | 10 | 10 |
| Number of observations | 32434489 | 1384617 |
| Missing cells | 2078068 | 0 |
| Missing cells (%) | 0.6% | 0.0% |
| Duplicate rows | 0 | 0 |
| Duplicate rows (%) | 0.0% | 0.0% |
| Total size in memory | 2.4 GiB | 105.6 MiB |
| Average record size in memory | 80.0 B | 80.0 B |
Variable types
| Prior Order Profile Report | Train Order Profile Report | |
|---|---|---|
| Numeric | 8 | 8 |
| Categorical | 2 | 2 |
| Prior Order Profile Report | Train Order Profile Report | |
|---|---|---|
eval_set has constant value "prior" | eval_set has constant value "train" | Constant |
days_since_prior_order has 2078068 (6.4%) missing values | Alert not present in this dataset | Missing |
order_dow has 6209666 (19.1%) zeros | order_dow has 324026 (23.4%) zeros | Zeros |
days_since_prior_order has 448698 (1.4%) zeros | days_since_prior_order has 17044 (1.2%) zeros | Zeros |
Reproduction
| Prior Order Profile Report | Train Order Profile Report | |
|---|---|---|
| Analysis started | 2024-11-01 20:57:22.573259 | 2024-11-01 21:07:35.426262 |
| Analysis finished | 2024-11-01 21:07:29.668437 | 2024-11-01 21:08:03.001191 |
| Duration | 10 minutes and 7.1 seconds | 27.57 seconds |
| Software version | ydata-profiling v0.0.dev0 | ydata-profiling v0.0.dev0 |
| Download configuration | config.json | config.json |
Variables
order_id
Real number (ℝ)
| Prior Order Profile Report | Train Order Profile Report | |
|---|---|---|
| Distinct | 3214874 | 131209 |
| Distinct (%) | 9.9% | 9.5% |
| Missing | 0 | 0 |
| Missing (%) | 0.0% | 0.0% |
| Infinite | 0 | 0 |
| Infinite (%) | 0.0% | 0.0% |
| Mean | 1710748.5 | 1706297.6 |
| Prior Order Profile Report | Train Order Profile Report | |
|---|---|---|
| Minimum | 2 | 1 |
| Maximum | 3421083 | 3421070 |
| Zeros | 0 | 0 |
| Zeros (%) | 0.0% | 0.0% |
| Negative | 0 | 0 |
| Negative (%) | 0.0% | 0.0% |
| Memory size | 247.5 MiB | 10.6 MiB |
Quantile statistics
| Prior Order Profile Report | Train Order Profile Report | |
|---|---|---|
| Minimum | 2 | 1 |
| 5-th percentile | 170925 | 170761 |
| Q1 | 855943 | 843370 |
| median | 1711048 | 1701880 |
| Q3 | 2565514 | 2568023 |
| 95-th percentile | 3250209 | 3249514.2 |
| Maximum | 3421083 | 3421070 |
| Range | 3421081 | 3421069 |
| Interquartile range (IQR) | 1709571 | 1724653 |
Descriptive statistics
| Prior Order Profile Report | Train Order Profile Report | |
|---|---|---|
| Standard deviation | 987300.7 | 989732.65 |
| Coefficient of variation (CV) | 0.57711621 | 0.5800469 |
| Kurtosis | -1.1991283 | -1.2066256 |
| Mean | 1710748.5 | 1706297.6 |
| Median Absolute Deviation (MAD) | 854783 | 861914 |
| Skewness | -0.00048974146 | 0.0063315648 |
| Sum | 5.5487254 × 1013 | 2.3625687 × 1012 |
| Variance | 9.7476267 × 1011 | 9.7957072 × 1011 |
| Monotonicity | Increasing | Increasing |
| Value | Count | Frequency (%) |
| 1564244 | 145 | < 0.1% |
| 790903 | 137 | < 0.1% |
| 61355 | 127 | < 0.1% |
| 2970392 | 121 | < 0.1% |
| 2069920 | 116 | < 0.1% |
| 3308010 | 115 | < 0.1% |
| 2753324 | 114 | < 0.1% |
| 2499774 | 112 | < 0.1% |
| 2621625 | 109 | < 0.1% |
| 77151 | 109 | < 0.1% |
| Other values (3214864) | 32433284 |
| Value | Count | Frequency (%) |
| 1395075 | 80 | < 0.1% |
| 2813632 | 80 | < 0.1% |
| 949182 | 77 | < 0.1% |
| 2869702 | 76 | < 0.1% |
| 341238 | 76 | < 0.1% |
| 312611 | 75 | < 0.1% |
| 1465173 | 74 | < 0.1% |
| 1355077 | 74 | < 0.1% |
| 653280 | 72 | < 0.1% |
| 288915 | 72 | < 0.1% |
| Other values (131199) | 1383861 |
| Value | Count | Frequency (%) |
| 2 | 9 | < 0.1% |
| 3 | 8 | < 0.1% |
| 4 | 13 | |
| 5 | 26 | |
| 6 | 3 | < 0.1% |
| 7 | 2 | < 0.1% |
| 8 | 1 | < 0.1% |
| 9 | 15 | |
| 10 | 15 | |
| 11 | 5 | < 0.1% |
| Value | Count | Frequency (%) |
| 1 | 8 | < 0.1% |
| 36 | 8 | < 0.1% |
| 38 | 9 | < 0.1% |
| 96 | 7 | < 0.1% |
| 98 | 49 | |
| 112 | 11 | < 0.1% |
| 170 | 17 | < 0.1% |
| 218 | 5 | < 0.1% |
| 226 | 13 | < 0.1% |
| 349 | 11 | < 0.1% |
| Value | Count | Frequency (%) |
| 1 | 8 | < 0.1% |
| 36 | 8 | < 0.1% |
| 38 | 9 | < 0.1% |
| 96 | 7 | < 0.1% |
| 98 | 49 | |
| 112 | 11 | < 0.1% |
| 170 | 17 | < 0.1% |
| 218 | 5 | < 0.1% |
| 226 | 13 | < 0.1% |
| 349 | 11 | < 0.1% |
| Value | Count | Frequency (%) |
| 2 | 9 | < 0.1% |
| 3 | 8 | < 0.1% |
| 4 | 13 | |
| 5 | 26 | |
| 6 | 3 | < 0.1% |
| 7 | 2 | < 0.1% |
| 8 | 1 | < 0.1% |
| 9 | 15 | |
| 10 | 15 | |
| 11 | 5 | < 0.1% |
product_id
Real number (ℝ)
| Prior Order Profile Report | Train Order Profile Report | |
|---|---|---|
| Distinct | 49677 | 39123 |
| Distinct (%) | 0.2% | 2.8% |
| Missing | 0 | 0 |
| Missing (%) | 0.0% | 0.0% |
| Infinite | 0 | 0 |
| Infinite (%) | 0.0% | 0.0% |
| Mean | 25576.338 | 25556.236 |
| Prior Order Profile Report | Train Order Profile Report | |
|---|---|---|
| Minimum | 1 | 1 |
| Maximum | 49688 | 49688 |
| Zeros | 0 | 0 |
| Zeros (%) | 0.0% | 0.0% |
| Negative | 0 | 0 |
| Negative (%) | 0.0% | 0.0% |
| Memory size | 247.5 MiB | 10.6 MiB |
Quantile statistics
| Prior Order Profile Report | Train Order Profile Report | |
|---|---|---|
| Minimum | 1 | 1 |
| 5-th percentile | 3376 | 3397 |
| Q1 | 13530 | 13380 |
| median | 25256 | 25298 |
| Q3 | 37935 | 37940 |
| 95-th percentile | 47559 | 47601 |
| Maximum | 49688 | 49688 |
| Range | 49687 | 49687 |
| Interquartile range (IQR) | 24405 | 24560 |
Descriptive statistics
| Prior Order Profile Report | Train Order Profile Report | |
|---|---|---|
| Standard deviation | 14096.689 | 14121.272 |
| Coefficient of variation (CV) | 0.55116136 | 0.55255682 |
| Kurtosis | -1.1408165 | -1.1537944 |
| Mean | 25576.338 | 25556.236 |
| Median Absolute Deviation (MAD) | 12080 | 12122 |
| Skewness | -0.021130583 | -0.022354791 |
| Sum | 8.2955544 × 1011 | 3.5385598 × 1010 |
| Variance | 1.9871664 × 108 | 1.9941034 × 108 |
| Monotonicity | Not monotonic | Not monotonic |
| Value | Count | Frequency (%) |
| 24852 | 472565 | 1.5% |
| 13176 | 379450 | 1.2% |
| 21137 | 264683 | 0.8% |
| 21903 | 241921 | 0.7% |
| 47209 | 213584 | 0.7% |
| 47766 | 176815 | 0.5% |
| 47626 | 152657 | 0.5% |
| 16797 | 142951 | 0.4% |
| 26209 | 140627 | 0.4% |
| 27845 | 137905 | 0.4% |
| Other values (49667) | 30111331 |
| Value | Count | Frequency (%) |
| 24852 | 18726 | 1.4% |
| 13176 | 15480 | 1.1% |
| 21137 | 10894 | 0.8% |
| 21903 | 9784 | 0.7% |
| 47626 | 8135 | 0.6% |
| 47766 | 7409 | 0.5% |
| 47209 | 7293 | 0.5% |
| 16797 | 6494 | 0.5% |
| 26209 | 6033 | 0.4% |
| 27966 | 5546 | 0.4% |
| Other values (39113) | 1288823 |
| Value | Count | Frequency (%) |
| 1 | 1852 | |
| 2 | 90 | < 0.1% |
| 3 | 277 | < 0.1% |
| 4 | 329 | < 0.1% |
| 5 | 15 | < 0.1% |
| 6 | 8 | < 0.1% |
| 7 | 30 | < 0.1% |
| 8 | 165 | < 0.1% |
| 9 | 156 | < 0.1% |
| 10 | 2572 |
| Value | Count | Frequency (%) |
| 1 | 76 | |
| 2 | 4 | < 0.1% |
| 3 | 6 | < 0.1% |
| 4 | 22 | < 0.1% |
| 5 | 1 | < 0.1% |
| 7 | 1 | < 0.1% |
| 8 | 13 | < 0.1% |
| 9 | 5 | < 0.1% |
| 10 | 119 | |
| 11 | 2 | < 0.1% |
| Value | Count | Frequency (%) |
| 1 | 76 | |
| 2 | 4 | < 0.1% |
| 3 | 6 | < 0.1% |
| 4 | 22 | < 0.1% |
| 5 | 1 | < 0.1% |
| 7 | 1 | < 0.1% |
| 8 | 13 | < 0.1% |
| 9 | 5 | < 0.1% |
| 10 | 119 | |
| 11 | 2 | < 0.1% |
| Value | Count | Frequency (%) |
| 1 | 1852 | |
| 2 | 90 | < 0.1% |
| 3 | 277 | < 0.1% |
| 4 | 329 | < 0.1% |
| 5 | 15 | < 0.1% |
| 6 | 8 | < 0.1% |
| 7 | 30 | < 0.1% |
| 8 | 165 | < 0.1% |
| 9 | 156 | < 0.1% |
| 10 | 2572 |
add_to_cart_order
Real number (ℝ)
| Prior Order Profile Report | Train Order Profile Report | |
|---|---|---|
| Distinct | 145 | 80 |
| Distinct (%) | < 0.1% | < 0.1% |
| Missing | 0 | 0 |
| Missing (%) | 0.0% | 0.0% |
| Infinite | 0 | 0 |
| Infinite (%) | 0.0% | 0.0% |
| Mean | 8.3510755 | 8.7580443 |
| Prior Order Profile Report | Train Order Profile Report | |
|---|---|---|
| Minimum | 1 | 1 |
| Maximum | 145 | 80 |
| Zeros | 0 | 0 |
| Zeros (%) | 0.0% | 0.0% |
| Negative | 0 | 0 |
| Negative (%) | 0.0% | 0.0% |
| Memory size | 247.5 MiB | 10.6 MiB |
Quantile statistics
| Prior Order Profile Report | Train Order Profile Report | |
|---|---|---|
| Minimum | 1 | 1 |
| 5-th percentile | 1 | 1 |
| Q1 | 3 | 3 |
| median | 6 | 7 |
| Q3 | 11 | 12 |
| 95-th percentile | 22 | 23 |
| Maximum | 145 | 80 |
| Range | 144 | 79 |
| Interquartile range (IQR) | 8 | 9 |
Descriptive statistics
| Prior Order Profile Report | Train Order Profile Report | |
|---|---|---|
| Standard deviation | 7.1266712 | 7.4239365 |
| Coefficient of variation (CV) | 0.85338363 | 0.84767058 |
| Kurtosis | 5.643873 | 4.1722265 |
| Mean | 8.3510755 | 8.7580443 |
| Median Absolute Deviation (MAD) | 4 | 4 |
| Skewness | 1.8180712 | 1.6855488 |
| Sum | 2.7086287 × 108 | 12126537 |
| Variance | 50.789442 | 55.114833 |
| Monotonicity | Not monotonic | Not monotonic |
| Value | Count | Frequency (%) |
| 1 | 3214874 | 9.9% |
| 2 | 3058126 | 9.4% |
| 3 | 2871133 | 8.9% |
| 4 | 2664106 | 8.2% |
| 5 | 2442025 | 7.5% |
| 6 | 2213695 | 6.8% |
| 7 | 1986020 | 6.1% |
| 8 | 1766014 | 5.4% |
| 9 | 1562640 | 4.8% |
| 10 | 1378293 | 4.2% |
| Other values (135) | 9277563 |
| Value | Count | Frequency (%) |
| 1 | 131209 | 9.5% |
| 2 | 124364 | 9.0% |
| 3 | 116996 | 8.4% |
| 4 | 108963 | 7.9% |
| 5 | 100745 | 7.3% |
| 6 | 91850 | 6.6% |
| 7 | 83142 | 6.0% |
| 8 | 74601 | 5.4% |
| 9 | 66618 | 4.8% |
| 10 | 59401 | 4.3% |
| Other values (70) | 426728 |
| Value | Count | Frequency (%) |
| 1 | 3214874 | |
| 2 | 3058126 | |
| 3 | 2871133 | |
| 4 | 2664106 | |
| 5 | 2442025 | |
| 6 | 2213695 | |
| 7 | 1986020 | |
| 8 | 1766014 | |
| 9 | 1562640 | |
| 10 | 1378293 |
| Value | Count | Frequency (%) |
| 1 | 131209 | |
| 2 | 124364 | |
| 3 | 116996 | |
| 4 | 108963 | |
| 5 | 100745 | |
| 6 | 91850 | |
| 7 | 83142 | |
| 8 | 74601 | |
| 9 | 66618 | |
| 10 | 59401 |
| Value | Count | Frequency (%) |
| 1 | 131209 | |
| 2 | 124364 | |
| 3 | 116996 | |
| 4 | 108963 | |
| 5 | 100745 | |
| 6 | 91850 | |
| 7 | 83142 | |
| 8 | 74601 | |
| 9 | 66618 | |
| 10 | 59401 |
| Value | Count | Frequency (%) |
| 1 | 3214874 | |
| 2 | 3058126 | |
| 3 | 2871133 | |
| 4 | 2664106 | |
| 5 | 2442025 | |
| 6 | 2213695 | |
| 7 | 1986020 | |
| 8 | 1766014 | |
| 9 | 1562640 | |
| 10 | 1378293 |
reordered
Categorical
| Prior Order Profile Report | Train Order Profile Report | |
|---|---|---|
| Distinct | 2 | 2 |
| Distinct (%) | < 0.1% | < 0.1% |
| Missing | 0 | 0 |
| Missing (%) | 0.0% | 0.0% |
| Memory size | 247.5 MiB | 10.6 MiB |
| 1 | |
|---|---|
| 0 |
| 1 | |
|---|---|
| 0 |
Length
| Prior Order Profile Report | Train Order Profile Report | |
|---|---|---|
| Max length | 1 | 1 |
| Median length | 1 | 1 |
| Mean length | 1 | 1 |
| Min length | 1 | 1 |
Characters and Unicode
| Prior Order Profile Report | Train Order Profile Report | |
|---|---|---|
| Total characters | 32434489 | 1384617 |
| Distinct characters | 2 | 2 |
| Distinct categories | 1 | 1 ? |
| Distinct scripts | 1 | 1 ? |
| Distinct blocks | 1 | 1 ? |
Unique
| Prior Order Profile Report | Train Order Profile Report | |
|---|---|---|
| Unique | 0 | 0 ? |
| Unique (%) | 0.0% | 0.0% |
Sample
| Prior Order Profile Report | Train Order Profile Report | |
|---|---|---|
| 1st row | 1 | 1 |
| 2nd row | 1 | 1 |
| 3rd row | 0 | 0 |
| 4th row | 1 | 0 |
| 5th row | 0 | 1 |
Common Values
| Value | Count | Frequency (%) |
| 1 | 19126536 | |
| 0 | 13307953 |
| Value | Count | Frequency (%) |
| 1 | 828824 | |
| 0 | 555793 |
Length
Common Values (Plot)
Prior Order Profile Report
Train Order Profile Report
| Value | Count | Frequency (%) |
| 1 | 19126536 | |
| 0 | 13307953 |
| Value | Count | Frequency (%) |
| 1 | 828824 | |
| 0 | 555793 |
Most occurring characters
| Value | Count | Frequency (%) |
| 1 | 19126536 | |
| 0 | 13307953 |
| Value | Count | Frequency (%) |
| 1 | 828824 | |
| 0 | 555793 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 32434489 |
| Value | Count | Frequency (%) |
| (unknown) | 1384617 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| 1 | 19126536 | |
| 0 | 13307953 |
| Value | Count | Frequency (%) |
| 1 | 828824 | |
| 0 | 555793 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 32434489 |
| Value | Count | Frequency (%) |
| (unknown) | 1384617 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| 1 | 19126536 | |
| 0 | 13307953 |
| Value | Count | Frequency (%) |
| 1 | 828824 | |
| 0 | 555793 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 32434489 |
| Value | Count | Frequency (%) |
| (unknown) | 1384617 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| 1 | 19126536 | |
| 0 | 13307953 |
| Value | Count | Frequency (%) |
| 1 | 828824 | |
| 0 | 555793 |
user_id
Real number (ℝ)
| Prior Order Profile Report | Train Order Profile Report | |
|---|---|---|
| Distinct | 206209 | 131209 |
| Distinct (%) | 0.6% | 9.5% |
| Missing | 0 | 0 |
| Missing (%) | 0.0% | 0.0% |
| Infinite | 0 | 0 |
| Infinite (%) | 0.0% | 0.0% |
| Mean | 102937.24 | 103112.78 |
| Prior Order Profile Report | Train Order Profile Report | |
|---|---|---|
| Minimum | 1 | 1 |
| Maximum | 206209 | 206209 |
| Zeros | 0 | 0 |
| Zeros (%) | 0.0% | 0.0% |
| Negative | 0 | 0 |
| Negative (%) | 0.0% | 0.0% |
| Memory size | 247.5 MiB | 10.6 MiB |
Quantile statistics
| Prior Order Profile Report | Train Order Profile Report | |
|---|---|---|
| Minimum | 1 | 1 |
| 5-th percentile | 10469 | 10425 |
| Q1 | 51421 | 51732 |
| median | 102611 | 102933 |
| Q3 | 154391 | 154959 |
| 95-th percentile | 195736 | 195696 |
| Maximum | 206209 | 206209 |
| Range | 206208 | 206208 |
| Interquartile range (IQR) | 102970 | 103227 |
Descriptive statistics
| Prior Order Profile Report | Train Order Profile Report | |
|---|---|---|
| Standard deviation | 59466.478 | 59487.148 |
| Coefficient of variation (CV) | 0.57769645 | 0.57691342 |
| Kurtosis | -1.2009235 | -1.2007212 |
| Mean | 102937.24 | 103112.78 |
| Median Absolute Deviation (MAD) | 51493 | 51608 |
| Skewness | 0.0066119537 | -0.0003274701 |
| Sum | 3.3387168 × 1012 | 1.4277171 × 1011 |
| Variance | 3.536262 × 109 | 3.5387208 × 109 |
| Monotonicity | Not monotonic | Not monotonic |
| Value | Count | Frequency (%) |
| 201268 | 3725 | < 0.1% |
| 129928 | 3638 | < 0.1% |
| 164055 | 3061 | < 0.1% |
| 186704 | 2936 | < 0.1% |
| 176478 | 2921 | < 0.1% |
| 182401 | 2907 | < 0.1% |
| 137629 | 2901 | < 0.1% |
| 33731 | 2888 | < 0.1% |
| 108187 | 2760 | < 0.1% |
| 4694 | 2735 | < 0.1% |
| Other values (206199) | 32404017 |
| Value | Count | Frequency (%) |
| 197541 | 80 | < 0.1% |
| 149753 | 80 | < 0.1% |
| 63458 | 77 | < 0.1% |
| 83993 | 76 | < 0.1% |
| 189951 | 76 | < 0.1% |
| 169647 | 75 | < 0.1% |
| 31611 | 74 | < 0.1% |
| 104741 | 74 | < 0.1% |
| 181991 | 72 | < 0.1% |
| 59321 | 72 | < 0.1% |
| Other values (131199) | 1383861 |
| Value | Count | Frequency (%) |
| 1 | 59 | < 0.1% |
| 2 | 195 | |
| 3 | 88 | |
| 4 | 18 | < 0.1% |
| 5 | 37 | < 0.1% |
| 6 | 14 | < 0.1% |
| 7 | 206 | |
| 8 | 49 | < 0.1% |
| 9 | 76 | < 0.1% |
| 10 | 143 |
| Value | Count | Frequency (%) |
| 1 | 11 | < 0.1% |
| 2 | 31 | |
| 5 | 9 | < 0.1% |
| 7 | 9 | < 0.1% |
| 8 | 18 | |
| 9 | 22 | |
| 10 | 4 | < 0.1% |
| 13 | 5 | < 0.1% |
| 14 | 11 | < 0.1% |
| 17 | 6 | < 0.1% |
| Value | Count | Frequency (%) |
| 1 | 11 | < 0.1% |
| 2 | 31 | |
| 5 | 9 | < 0.1% |
| 7 | 9 | < 0.1% |
| 8 | 18 | |
| 9 | 22 | |
| 10 | 4 | < 0.1% |
| 13 | 5 | < 0.1% |
| 14 | 11 | < 0.1% |
| 17 | 6 | < 0.1% |
| Value | Count | Frequency (%) |
| 1 | 59 | < 0.1% |
| 2 | 195 | |
| 3 | 88 | |
| 4 | 18 | < 0.1% |
| 5 | 37 | < 0.1% |
| 6 | 14 | < 0.1% |
| 7 | 206 | |
| 8 | 49 | < 0.1% |
| 9 | 76 | < 0.1% |
| 10 | 143 |
eval_set
Categorical
| Prior Order Profile Report | Train Order Profile Report | |
|---|---|---|
| Distinct | 1 | 1 |
| Distinct (%) | < 0.1% | < 0.1% |
| Missing | 0 | 0 |
| Missing (%) | 0.0% | 0.0% |
| Memory size | 247.5 MiB | 10.6 MiB |
| prior |
|---|
| train |
|---|
Length
| Prior Order Profile Report | Train Order Profile Report | |
|---|---|---|
| Max length | 5 | 5 |
| Median length | 5 | 5 |
| Mean length | 5 | 5 |
| Min length | 5 | 5 |
Characters and Unicode
| Prior Order Profile Report | Train Order Profile Report | |
|---|---|---|
| Total characters | 162172445 | 6923085 |
| Distinct characters | 4 | 5 |
| Distinct categories | 1 | 1 ? |
| Distinct scripts | 1 | 1 ? |
| Distinct blocks | 1 | 1 ? |
Unique
| Prior Order Profile Report | Train Order Profile Report | |
|---|---|---|
| Unique | 0 | 0 ? |
| Unique (%) | 0.0% | 0.0% |
Sample
| Prior Order Profile Report | Train Order Profile Report | |
|---|---|---|
| 1st row | prior | train |
| 2nd row | prior | train |
| 3rd row | prior | train |
| 4th row | prior | train |
| 5th row | prior | train |
Common Values
| Value | Count | Frequency (%) |
| prior | 32434489 |
| Value | Count | Frequency (%) |
| train | 1384617 |
Length
Common Values (Plot)
Prior Order Profile Report
Train Order Profile Report
| Value | Count | Frequency (%) |
| prior | 32434489 |
| Value | Count | Frequency (%) |
| train | 1384617 |
Most occurring characters
| Value | Count | Frequency (%) |
| r | 64868978 | |
| p | 32434489 | |
| i | 32434489 | |
| o | 32434489 |
| Value | Count | Frequency (%) |
| t | 1384617 | |
| r | 1384617 | |
| a | 1384617 | |
| i | 1384617 | |
| n | 1384617 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 162172445 |
| Value | Count | Frequency (%) |
| (unknown) | 6923085 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| r | 64868978 | |
| p | 32434489 | |
| i | 32434489 | |
| o | 32434489 |
| Value | Count | Frequency (%) |
| t | 1384617 | |
| r | 1384617 | |
| a | 1384617 | |
| i | 1384617 | |
| n | 1384617 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 162172445 |
| Value | Count | Frequency (%) |
| (unknown) | 6923085 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| r | 64868978 | |
| p | 32434489 | |
| i | 32434489 | |
| o | 32434489 |
| Value | Count | Frequency (%) |
| t | 1384617 | |
| r | 1384617 | |
| a | 1384617 | |
| i | 1384617 | |
| n | 1384617 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 162172445 |
| Value | Count | Frequency (%) |
| (unknown) | 6923085 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| r | 64868978 | |
| p | 32434489 | |
| i | 32434489 | |
| o | 32434489 |
| Value | Count | Frequency (%) |
| t | 1384617 | |
| r | 1384617 | |
| a | 1384617 | |
| i | 1384617 | |
| n | 1384617 |
order_number
Real number (ℝ)
| Prior Order Profile Report | Train Order Profile Report | |
|---|---|---|
| Distinct | 99 | 97 |
| Distinct (%) | < 0.1% | < 0.1% |
| Missing | 0 | 0 |
| Missing (%) | 0.0% | 0.0% |
| Infinite | 0 | 0 |
| Infinite (%) | 0.0% | 0.0% |
| Mean | 17.14205 | 17.09141 |
| Prior Order Profile Report | Train Order Profile Report | |
|---|---|---|
| Minimum | 1 | 4 |
| Maximum | 99 | 100 |
| Zeros | 0 | 0 |
| Zeros (%) | 0.0% | 0.0% |
| Negative | 0 | 0 |
| Negative (%) | 0.0% | 0.0% |
| Memory size | 247.5 MiB | 10.6 MiB |
Quantile statistics
| Prior Order Profile Report | Train Order Profile Report | |
|---|---|---|
| Minimum | 1 | 4 |
| 5-th percentile | 1 | 4 |
| Q1 | 5 | 6 |
| median | 11 | 11 |
| Q3 | 24 | 21 |
| 95-th percentile | 54 | 52 |
| Maximum | 99 | 100 |
| Range | 98 | 96 |
| Interquartile range (IQR) | 19 | 15 |
Descriptive statistics
| Prior Order Profile Report | Train Order Profile Report | |
|---|---|---|
| Standard deviation | 17.53504 | 16.614037 |
| Coefficient of variation (CV) | 1.0229255 | 0.97206939 |
| Kurtosis | 3.256605 | 5.8967139 |
| Mean | 17.14205 | 17.09141 |
| Median Absolute Deviation (MAD) | 8 | 6 |
| Skewness | 1.7568963 | 2.2433716 |
| Sum | 5.5599364 × 108 | 23665057 |
| Variance | 307.47765 | 276.02621 |
| Monotonicity | Not monotonic | Not monotonic |
| Value | Count | Frequency (%) |
| 1 | 2078068 | 6.4% |
| 3 | 2050731 | 6.3% |
| 2 | 2048332 | 6.3% |
| 4 | 1820298 | 5.6% |
| 5 | 1628411 | 5.0% |
| 6 | 1472238 | 4.5% |
| 7 | 1333847 | 4.1% |
| 8 | 1219148 | 3.8% |
| 9 | 1120468 | 3.5% |
| 10 | 1028704 | 3.2% |
| Other values (89) | 16634244 |
| Value | Count | Frequency (%) |
| 4 | 149882 | 10.8% |
| 5 | 123548 | 8.9% |
| 6 | 105328 | 7.6% |
| 7 | 90949 | 6.6% |
| 8 | 75645 | 5.5% |
| 9 | 68366 | 4.9% |
| 10 | 60216 | 4.3% |
| 11 | 51530 | 3.7% |
| 12 | 47819 | 3.5% |
| 13 | 42072 | 3.0% |
| Other values (87) | 569262 |
| Value | Count | Frequency (%) |
| 1 | 2078068 | |
| 2 | 2048332 | |
| 3 | 2050731 | |
| 4 | 1820298 | |
| 5 | 1628411 | |
| 6 | 1472238 | |
| 7 | 1333847 | |
| 8 | 1219148 | |
| 9 | 1120468 | |
| 10 | 1028704 |
| Value | Count | Frequency (%) |
| 4 | 149882 | |
| 5 | 123548 | |
| 6 | 105328 | |
| 7 | 90949 | |
| 8 | 75645 | |
| 9 | 68366 | |
| 10 | 60216 | |
| 11 | 51530 | 3.7% |
| 12 | 47819 | 3.5% |
| 13 | 42072 | 3.0% |
| Value | Count | Frequency (%) |
| 4 | 149882 | |
| 5 | 123548 | |
| 6 | 105328 | |
| 7 | 90949 | |
| 8 | 75645 | |
| 9 | 68366 | |
| 10 | 60216 | |
| 11 | 51530 | 0.2% |
| 12 | 47819 | 0.1% |
| 13 | 42072 | 0.1% |
| Value | Count | Frequency (%) |
| 1 | 2078068 | |
| 2 | 2048332 | |
| 3 | 2050731 | |
| 4 | 1820298 | |
| 5 | 1628411 | |
| 6 | 1472238 | |
| 7 | 1333847 | |
| 8 | 1219148 | |
| 9 | 1120468 | |
| 10 | 1028704 |
order_dow
Real number (ℝ)
| Prior Order Profile Report | Train Order Profile Report | |
|---|---|---|
| Distinct | 7 | 7 |
| Distinct (%) | < 0.1% | < 0.1% |
| Missing | 0 | 0 |
| Missing (%) | 0.0% | 0.0% |
| Infinite | 0 | 0 |
| Infinite (%) | 0.0% | 0.0% |
| Mean | 2.7388177 | 2.7013918 |
| Prior Order Profile Report | Train Order Profile Report | |
|---|---|---|
| Minimum | 0 | 0 |
| Maximum | 6 | 6 |
| Zeros | 6209666 | 324026 |
| Zeros (%) | 19.1% | 23.4% |
| Negative | 0 | 0 |
| Negative (%) | 0.0% | 0.0% |
| Memory size | 247.5 MiB | 10.6 MiB |
Quantile statistics
| Prior Order Profile Report | Train Order Profile Report | |
|---|---|---|
| Minimum | 0 | 0 |
| 5-th percentile | 0 | 0 |
| Q1 | 1 | 1 |
| median | 3 | 3 |
| Q3 | 5 | 5 |
| 95-th percentile | 6 | 6 |
| Maximum | 6 | 6 |
| Range | 6 | 6 |
| Interquartile range (IQR) | 4 | 4 |
Descriptive statistics
| Prior Order Profile Report | Train Order Profile Report | |
|---|---|---|
| Standard deviation | 2.0900491 | 2.1676456 |
| Coefficient of variation (CV) | 0.76312092 | 0.80241809 |
| Kurtosis | -1.3339893 | -1.3989458 |
| Mean | 2.7388177 | 2.7013918 |
| Median Absolute Deviation (MAD) | 2 | 2 |
| Skewness | 0.18019293 | 0.1755159 |
| Sum | 88832152 | 3740393 |
| Variance | 4.3683052 | 4.6986876 |
| Monotonicity | Not monotonic | Not monotonic |
| Value | Count | Frequency (%) |
| 0 | 6209666 | |
| 1 | 5665856 | |
| 6 | 4500304 | |
| 2 | 4217798 | |
| 5 | 4209533 | |
| 3 | 3844117 | |
| 4 | 3787215 |
| Value | Count | Frequency (%) |
| 0 | 324026 | |
| 6 | 207279 | |
| 1 | 205978 | |
| 5 | 176910 | |
| 2 | 160562 | |
| 4 | 155481 | |
| 3 | 154381 |
| Value | Count | Frequency (%) |
| 0 | 6209666 | |
| 1 | 5665856 | |
| 2 | 4217798 | |
| 3 | 3844117 | |
| 4 | 3787215 | |
| 5 | 4209533 | |
| 6 | 4500304 |
| Value | Count | Frequency (%) |
| 0 | 324026 | |
| 1 | 205978 | |
| 2 | 160562 | |
| 3 | 154381 | |
| 4 | 155481 | |
| 5 | 176910 | |
| 6 | 207279 |
| Value | Count | Frequency (%) |
| 0 | 324026 | |
| 1 | 205978 | |
| 2 | 160562 | |
| 3 | 154381 | |
| 4 | 155481 | |
| 5 | 176910 | |
| 6 | 207279 |
| Value | Count | Frequency (%) |
| 0 | 6209666 | |
| 1 | 5665856 | |
| 2 | 4217798 | |
| 3 | 3844117 | |
| 4 | 3787215 | |
| 5 | 4209533 | |
| 6 | 4500304 |
order_hour_of_day
Real number (ℝ)
| Prior Order Profile Report | Train Order Profile Report | |
|---|---|---|
| Distinct | 24 | 24 |
| Distinct (%) | < 0.1% | < 0.1% |
| Missing | 0 | 0 |
| Missing (%) | 0.0% | 0.0% |
| Infinite | 0 | 0 |
| Infinite (%) | 0.0% | 0.0% |
| Mean | 13.424977 | 13.577592 |
| Prior Order Profile Report | Train Order Profile Report | |
|---|---|---|
| Minimum | 0 | 0 |
| Maximum | 23 | 23 |
| Zeros | 218948 | 9083 |
| Zeros (%) | 0.7% | 0.7% |
| Negative | 0 | 0 |
| Negative (%) | 0.0% | 0.0% |
| Memory size | 247.5 MiB | 10.6 MiB |
Quantile statistics
| Prior Order Profile Report | Train Order Profile Report | |
|---|---|---|
| Minimum | 0 | 0 |
| 5-th percentile | 7 | 7 |
| Q1 | 10 | 10 |
| median | 13 | 14 |
| Q3 | 16 | 17 |
| 95-th percentile | 21 | 21 |
| Maximum | 23 | 23 |
| Range | 23 | 23 |
| Interquartile range (IQR) | 6 | 7 |
Descriptive statistics
| Prior Order Profile Report | Train Order Profile Report | |
|---|---|---|
| Standard deviation | 4.246365 | 4.238458 |
| Coefficient of variation (CV) | 0.31630333 | 0.31216566 |
| Kurtosis | -0.011657572 | 0.043845727 |
| Mean | 13.424977 | 13.577592 |
| Median Absolute Deviation (MAD) | 3 | 3 |
| Skewness | -0.044082776 | -0.12102981 |
| Sum | 4.3543228 × 108 | 18799765 |
| Variance | 18.031616 | 17.964526 |
| Monotonicity | Not monotonic | Not monotonic |
| Value | Count | Frequency (%) |
| 10 | 2764426 | 8.5% |
| 11 | 2738582 | 8.4% |
| 14 | 2691548 | 8.3% |
| 15 | 2664533 | 8.2% |
| 13 | 2663292 | 8.2% |
| 12 | 2620847 | 8.1% |
| 16 | 2537458 | 7.8% |
| 9 | 2456713 | 7.6% |
| 17 | 2089465 | 6.4% |
| 8 | 1719973 | 5.3% |
| Other values (14) | 7487652 |
| Value | Count | Frequency (%) |
| 14 | 119370 | 8.6% |
| 15 | 116198 | 8.4% |
| 13 | 114762 | 8.3% |
| 11 | 114119 | 8.2% |
| 12 | 111752 | 8.1% |
| 10 | 110479 | 8.0% |
| 16 | 110237 | 8.0% |
| 17 | 96944 | 7.0% |
| 9 | 93856 | 6.8% |
| 18 | 76522 | 5.5% |
| Other values (14) | 320378 |
| Value | Count | Frequency (%) |
| 0 | 218948 | 0.7% |
| 1 | 115786 | 0.4% |
| 2 | 69434 | 0.2% |
| 3 | 51321 | 0.2% |
| 4 | 53283 | 0.2% |
| 5 | 88062 | 0.3% |
| 6 | 290795 | 0.9% |
| 7 | 891937 | 2.7% |
| 8 | 1719973 | |
| 9 | 2456713 |
| Value | Count | Frequency (%) |
| 0 | 9083 | 0.7% |
| 1 | 5626 | 0.4% |
| 2 | 3226 | 0.2% |
| 3 | 2438 | 0.2% |
| 4 | 2431 | 0.2% |
| 5 | 3847 | 0.3% |
| 6 | 11847 | 0.9% |
| 7 | 36302 | 2.6% |
| 8 | 67386 | |
| 9 | 93856 |
| Value | Count | Frequency (%) |
| 0 | 9083 | < 0.1% |
| 1 | 5626 | < 0.1% |
| 2 | 3226 | < 0.1% |
| 3 | 2438 | < 0.1% |
| 4 | 2431 | < 0.1% |
| 5 | 3847 | < 0.1% |
| 6 | 11847 | < 0.1% |
| 7 | 36302 | 0.1% |
| 8 | 67386 | |
| 9 | 93856 |
| Value | Count | Frequency (%) |
| 0 | 218948 | 15.8% |
| 1 | 115786 | 8.4% |
| 2 | 69434 | 5.0% |
| 3 | 51321 | 3.7% |
| 4 | 53283 | 3.8% |
| 5 | 88062 | 6.4% |
| 6 | 290795 | 21.0% |
| 7 | 891937 | 64.4% |
| 8 | 1719973 | |
| 9 | 2456713 |
days_since_prior_order
Real number (ℝ)
| Prior Order Profile Report | Train Order Profile Report | |
|---|---|---|
| Distinct | 31 | 31 |
| Distinct (%) | < 0.1% | < 0.1% |
| Missing | 2078068 | 0 |
| Missing (%) | 6.4% | 0.0% |
| Infinite | 0 | 0 |
| Infinite (%) | 0.0% | 0.0% |
| Mean | 11.104074 | 17.066126 |
| Prior Order Profile Report | Train Order Profile Report | |
|---|---|---|
| Minimum | 0 | 0 |
| Maximum | 30 | 30 |
| Zeros | 448698 | 17044 |
| Zeros (%) | 1.4% | 1.2% |
| Negative | 0 | 0 |
| Negative (%) | 0.0% | 0.0% |
| Memory size | 247.5 MiB | 10.6 MiB |
Quantile statistics
| Prior Order Profile Report | Train Order Profile Report | |
|---|---|---|
| Minimum | 0 | 0 |
| 5-th percentile | 2 | 3 |
| Q1 | 5 | 7 |
| median | 8 | 15 |
| Q3 | 15 | 30 |
| 95-th percentile | 30 | 30 |
| Maximum | 30 | 30 |
| Range | 30 | 30 |
| Interquartile range (IQR) | 10 | 23 |
Descriptive statistics
| Prior Order Profile Report | Train Order Profile Report | |
|---|---|---|
| Standard deviation | 8.7789143 | 10.426418 |
| Coefficient of variation (CV) | 0.79060299 | 0.61094228 |
| Kurtosis | -0.068967377 | -1.5712889 |
| Mean | 11.104074 | 17.066126 |
| Median Absolute Deviation (MAD) | 4 | 9 |
| Skewness | 1.0539722 | 0.074891246 |
| Sum | 3.3707995 × 108 | 23630048 |
| Variance | 77.069337 | 108.71019 |
| Monotonicity | Not monotonic | Not monotonic |
| Value | Count | Frequency (%) |
| 7 | 3479504 | 10.7% |
| 30 | 3070057 | 9.5% |
| 6 | 2519939 | 7.8% |
| 5 | 2126420 | 6.6% |
| 4 | 2080560 | 6.4% |
| 8 | 1933815 | 6.0% |
| 3 | 1877881 | 5.8% |
| 2 | 1464875 | 4.5% |
| 9 | 1218973 | 3.8% |
| 14 | 1030605 | 3.2% |
| Other values (21) | 9553792 | |
| (Missing) | 2078068 | 6.4% |
| Value | Count | Frequency (%) |
| 30 | 407265 | |
| 7 | 106801 | 7.7% |
| 6 | 72138 | 5.2% |
| 8 | 61821 | 4.5% |
| 5 | 54117 | 3.9% |
| 14 | 51690 | 3.7% |
| 4 | 45727 | 3.3% |
| 9 | 43410 | 3.1% |
| 13 | 39081 | 2.8% |
| 3 | 36550 | 2.6% |
| Other values (21) | 466017 |
| Value | Count | Frequency (%) |
| 0 | 448698 | 1.4% |
| 1 | 941116 | 2.9% |
| 2 | 1464875 | |
| 3 | 1877881 | |
| 4 | 2080560 | |
| 5 | 2126420 | |
| 6 | 2519939 | |
| 7 | 3479504 | |
| 8 | 1933815 | |
| 9 | 1218973 | 3.8% |
| Value | Count | Frequency (%) |
| 0 | 17044 | 1.2% |
| 1 | 19265 | 1.4% |
| 2 | 27504 | 2.0% |
| 3 | 36550 | 2.6% |
| 4 | 45727 | |
| 5 | 54117 | |
| 6 | 72138 | |
| 7 | 106801 | |
| 8 | 61821 | |
| 9 | 43410 |
| Value | Count | Frequency (%) |
| 0 | 17044 | 0.1% |
| 1 | 19265 | 0.1% |
| 2 | 27504 | 0.1% |
| 3 | 36550 | 0.1% |
| 4 | 45727 | |
| 5 | 54117 | |
| 6 | 72138 | |
| 7 | 106801 | |
| 8 | 61821 | |
| 9 | 43410 |
| Value | Count | Frequency (%) |
| 0 | 448698 | 32.4% |
| 1 | 941116 | 68.0% |
| 2 | 1464875 | |
| 3 | 1877881 | |
| 4 | 2080560 | |
| 5 | 2126420 | |
| 6 | 2519939 | |
| 7 | 3479504 | |
| 8 | 1933815 | |
| 9 | 1218973 | 88.0% |
Interactions
Prior Order Profile Report
Train Order Profile Report
Prior Order Profile Report
Train Order Profile Report
Prior Order Profile Report
Train Order Profile Report
Prior Order Profile Report
Train Order Profile Report
Prior Order Profile Report
Train Order Profile Report
Prior Order Profile Report
Train Order Profile Report
Prior Order Profile Report
Train Order Profile Report
Prior Order Profile Report
Train Order Profile Report
Prior Order Profile Report
Train Order Profile Report
Prior Order Profile Report
Train Order Profile Report
Prior Order Profile Report
Train Order Profile Report
Prior Order Profile Report
Train Order Profile Report
Prior Order Profile Report
Train Order Profile Report
Prior Order Profile Report
Train Order Profile Report
Prior Order Profile Report
Train Order Profile Report
Prior Order Profile Report
Train Order Profile Report
Prior Order Profile Report
Train Order Profile Report
Prior Order Profile Report
Train Order Profile Report
Prior Order Profile Report
Train Order Profile Report
Prior Order Profile Report
Train Order Profile Report
Prior Order Profile Report
Train Order Profile Report
Prior Order Profile Report
Train Order Profile Report
Prior Order Profile Report
Train Order Profile Report
Prior Order Profile Report
Train Order Profile Report
Prior Order Profile Report
Train Order Profile Report
Prior Order Profile Report
Train Order Profile Report
Prior Order Profile Report
Train Order Profile Report
Prior Order Profile Report
Train Order Profile Report
Prior Order Profile Report
Train Order Profile Report
Prior Order Profile Report
Train Order Profile Report
Prior Order Profile Report
Train Order Profile Report
Prior Order Profile Report
Train Order Profile Report
Prior Order Profile Report
Train Order Profile Report
Prior Order Profile Report
Train Order Profile Report
Prior Order Profile Report
Train Order Profile Report
Prior Order Profile Report
Train Order Profile Report
Prior Order Profile Report
Train Order Profile Report
Prior Order Profile Report
Train Order Profile Report
Prior Order Profile Report
Train Order Profile Report
Prior Order Profile Report
Train Order Profile Report
Prior Order Profile Report
Train Order Profile Report
Prior Order Profile Report
Train Order Profile Report
Prior Order Profile Report
Train Order Profile Report
Prior Order Profile Report
Train Order Profile Report
Prior Order Profile Report
Train Order Profile Report
Prior Order Profile Report
Train Order Profile Report
Prior Order Profile Report
Train Order Profile Report
Prior Order Profile Report
Train Order Profile Report
Prior Order Profile Report
Train Order Profile Report
Prior Order Profile Report
Train Order Profile Report
Prior Order Profile Report
Train Order Profile Report
Prior Order Profile Report
Train Order Profile Report
Prior Order Profile Report
Train Order Profile Report
Prior Order Profile Report
Train Order Profile Report
Prior Order Profile Report
Train Order Profile Report
Prior Order Profile Report
Train Order Profile Report
Prior Order Profile Report
Train Order Profile Report
Prior Order Profile Report
Train Order Profile Report
Prior Order Profile Report
Train Order Profile Report
Prior Order Profile Report
Train Order Profile Report
Prior Order Profile Report
Train Order Profile Report
Prior Order Profile Report
Train Order Profile Report
Prior Order Profile Report
Train Order Profile Report
Prior Order Profile Report
Train Order Profile Report
Correlations
Prior Order Profile Report
Train Order Profile Report
Prior Order Profile Report
| add_to_cart_order | days_since_prior_order | order_dow | order_hour_of_day | order_id | order_number | product_id | reordered | user_id | |
|---|---|---|---|---|---|---|---|---|---|
| add_to_cart_order | 1.000 | 0.078 | -0.015 | -0.015 | -0.000 | 0.000 | 0.009 | 0.096 | 0.000 |
| days_since_prior_order | 0.078 | 1.000 | -0.043 | -0.004 | -0.000 | -0.385 | 0.001 | 0.140 | 0.000 |
| order_dow | -0.015 | -0.043 | 1.000 | 0.012 | 0.001 | 0.015 | -0.003 | 0.018 | -0.002 |
| order_hour_of_day | -0.015 | -0.004 | 0.012 | 1.000 | 0.001 | -0.048 | 0.001 | 0.038 | 0.000 |
| order_id | -0.000 | -0.000 | 0.001 | 0.001 | 1.000 | -0.000 | -0.000 | 0.001 | -0.000 |
| order_number | 0.000 | -0.385 | 0.015 | -0.048 | -0.000 | 1.000 | -0.002 | 0.341 | -0.001 |
| product_id | 0.009 | 0.001 | -0.003 | 0.001 | -0.000 | -0.002 | 1.000 | 0.040 | 0.000 |
| reordered | 0.096 | 0.140 | 0.018 | 0.038 | 0.001 | 0.341 | 0.040 | 1.000 | 0.004 |
| user_id | 0.000 | 0.000 | -0.002 | 0.000 | -0.000 | -0.001 | 0.000 | 0.004 | 1.000 |
Train Order Profile Report
| add_to_cart_order | days_since_prior_order | order_dow | order_hour_of_day | order_id | order_number | product_id | reordered | user_id | |
|---|---|---|---|---|---|---|---|---|---|
| add_to_cart_order | 1.000 | 0.018 | -0.024 | -0.010 | 0.002 | 0.031 | 0.007 | 0.137 | -0.000 |
| days_since_prior_order | 0.018 | 1.000 | -0.025 | 0.008 | 0.003 | -0.387 | 0.001 | 0.166 | 0.004 |
| order_dow | -0.024 | -0.025 | 1.000 | 0.009 | 0.001 | 0.015 | -0.004 | 0.017 | -0.006 |
| order_hour_of_day | -0.010 | 0.008 | 0.009 | 1.000 | -0.003 | -0.035 | 0.002 | 0.034 | -0.001 |
| order_id | 0.002 | 0.003 | 0.001 | -0.003 | 1.000 | 0.002 | -0.001 | 0.004 | -0.001 |
| order_number | 0.031 | -0.387 | 0.015 | -0.035 | 0.002 | 1.000 | -0.001 | 0.237 | -0.005 |
| product_id | 0.007 | 0.001 | -0.004 | 0.002 | -0.001 | -0.001 | 1.000 | 0.042 | -0.001 |
| reordered | 0.137 | 0.166 | 0.017 | 0.034 | 0.004 | 0.237 | 0.042 | 1.000 | 0.006 |
| user_id | -0.000 | 0.004 | -0.006 | -0.001 | -0.001 | -0.005 | -0.001 | 0.006 | 1.000 |
Missing values
Prior Order Profile Report
Train Order Profile Report
Prior Order Profile Report
Train Order Profile Report
Sample
Prior Order Profile Report
| order_id | product_id | add_to_cart_order | reordered | user_id | eval_set | order_number | order_dow | order_hour_of_day | days_since_prior_order | |
|---|---|---|---|---|---|---|---|---|---|---|
| 0 | 2 | 33120 | 1 | 1 | 202279 | prior | 3 | 5 | 9 | 8.0 |
| 1 | 2 | 28985 | 2 | 1 | 202279 | prior | 3 | 5 | 9 | 8.0 |
| 2 | 2 | 9327 | 3 | 0 | 202279 | prior | 3 | 5 | 9 | 8.0 |
| 3 | 2 | 45918 | 4 | 1 | 202279 | prior | 3 | 5 | 9 | 8.0 |
| 4 | 2 | 30035 | 5 | 0 | 202279 | prior | 3 | 5 | 9 | 8.0 |
| 5 | 2 | 17794 | 6 | 1 | 202279 | prior | 3 | 5 | 9 | 8.0 |
| 6 | 2 | 40141 | 7 | 1 | 202279 | prior | 3 | 5 | 9 | 8.0 |
| 7 | 2 | 1819 | 8 | 1 | 202279 | prior | 3 | 5 | 9 | 8.0 |
| 8 | 2 | 43668 | 9 | 0 | 202279 | prior | 3 | 5 | 9 | 8.0 |
| 9 | 3 | 33754 | 1 | 1 | 205970 | prior | 16 | 5 | 17 | 12.0 |
Train Order Profile Report
| order_id | product_id | add_to_cart_order | reordered | user_id | eval_set | order_number | order_dow | order_hour_of_day | days_since_prior_order | |
|---|---|---|---|---|---|---|---|---|---|---|
| 0 | 1 | 49302 | 1 | 1 | 112108 | train | 4 | 4 | 10 | 9.0 |
| 1 | 1 | 11109 | 2 | 1 | 112108 | train | 4 | 4 | 10 | 9.0 |
| 2 | 1 | 10246 | 3 | 0 | 112108 | train | 4 | 4 | 10 | 9.0 |
| 3 | 1 | 49683 | 4 | 0 | 112108 | train | 4 | 4 | 10 | 9.0 |
| 4 | 1 | 43633 | 5 | 1 | 112108 | train | 4 | 4 | 10 | 9.0 |
| 5 | 1 | 13176 | 6 | 0 | 112108 | train | 4 | 4 | 10 | 9.0 |
| 6 | 1 | 47209 | 7 | 0 | 112108 | train | 4 | 4 | 10 | 9.0 |
| 7 | 1 | 22035 | 8 | 1 | 112108 | train | 4 | 4 | 10 | 9.0 |
| 8 | 36 | 39612 | 1 | 0 | 79431 | train | 23 | 6 | 18 | 30.0 |
| 9 | 36 | 19660 | 2 | 1 | 79431 | train | 23 | 6 | 18 | 30.0 |
Prior Order Profile Report
| order_id | product_id | add_to_cart_order | reordered | user_id | eval_set | order_number | order_dow | order_hour_of_day | days_since_prior_order | |
|---|---|---|---|---|---|---|---|---|---|---|
| 32434479 | 3421083 | 7854 | 1 | 0 | 25247 | prior | 24 | 2 | 6 | 21.0 |
| 32434480 | 3421083 | 45309 | 2 | 0 | 25247 | prior | 24 | 2 | 6 | 21.0 |
| 32434481 | 3421083 | 21162 | 3 | 0 | 25247 | prior | 24 | 2 | 6 | 21.0 |
| 32434482 | 3421083 | 18176 | 4 | 1 | 25247 | prior | 24 | 2 | 6 | 21.0 |
| 32434483 | 3421083 | 35211 | 5 | 0 | 25247 | prior | 24 | 2 | 6 | 21.0 |
| 32434484 | 3421083 | 39678 | 6 | 1 | 25247 | prior | 24 | 2 | 6 | 21.0 |
| 32434485 | 3421083 | 11352 | 7 | 0 | 25247 | prior | 24 | 2 | 6 | 21.0 |
| 32434486 | 3421083 | 4600 | 8 | 0 | 25247 | prior | 24 | 2 | 6 | 21.0 |
| 32434487 | 3421083 | 24852 | 9 | 1 | 25247 | prior | 24 | 2 | 6 | 21.0 |
| 32434488 | 3421083 | 5020 | 10 | 1 | 25247 | prior | 24 | 2 | 6 | 21.0 |
Train Order Profile Report
| order_id | product_id | add_to_cart_order | reordered | user_id | eval_set | order_number | order_dow | order_hour_of_day | days_since_prior_order | |
|---|---|---|---|---|---|---|---|---|---|---|
| 1384607 | 3421058 | 30316 | 6 | 1 | 136952 | train | 20 | 3 | 18 | 15.0 |
| 1384608 | 3421058 | 35578 | 7 | 0 | 136952 | train | 20 | 3 | 18 | 15.0 |
| 1384609 | 3421058 | 32650 | 8 | 1 | 136952 | train | 20 | 3 | 18 | 15.0 |
| 1384610 | 3421063 | 49235 | 1 | 1 | 169679 | train | 30 | 0 | 10 | 4.0 |
| 1384611 | 3421063 | 13565 | 2 | 1 | 169679 | train | 30 | 0 | 10 | 4.0 |
| 1384612 | 3421063 | 14233 | 3 | 1 | 169679 | train | 30 | 0 | 10 | 4.0 |
| 1384613 | 3421063 | 35548 | 4 | 1 | 169679 | train | 30 | 0 | 10 | 4.0 |
| 1384614 | 3421070 | 35951 | 1 | 1 | 139822 | train | 15 | 6 | 10 | 8.0 |
| 1384615 | 3421070 | 16953 | 2 | 1 | 139822 | train | 15 | 6 | 10 | 8.0 |
| 1384616 | 3421070 | 4724 | 3 | 1 | 139822 | train | 15 | 6 | 10 | 8.0 |
Duplicate rows
Prior Order Profile Report
| order_id | product_id | add_to_cart_order | reordered | user_id | eval_set | order_number | order_dow | order_hour_of_day | days_since_prior_order | # duplicates | |
|---|---|---|---|---|---|---|---|---|---|---|---|
| Dataset does not contain duplicate rows. | |||||||||||
Train Order Profile Report
| order_id | product_id | add_to_cart_order | reordered | user_id | eval_set | order_number | order_dow | order_hour_of_day | days_since_prior_order | # duplicates | |
|---|---|---|---|---|---|---|---|---|---|---|---|
| Dataset does not contain duplicate rows. | |||||||||||